Re: Finding records that are not there

At 6:47 PM +0200 5/22/08, hubert depesz lubaczewski wrote:
>On Thu, May 22, 2008 at 12:21:35PM -0400, Owen Hartnett wrote:
>>  The SQL I've tried is:
>>  select commcost.maplot, commcost.unitno from commcost
>>  where not exists(select 1 from commcost, bldg
>>  where commcost.maplot = bldg.maplot and
>>  commcost.unitno = bldg.unitno)
>>  order by commcost.maplot
>
>change it to:
>
>>  select commcost.maplot, commcost.unitno from commcost
>>  where not exists(select 1 from bldg
>>  where commcost.maplot = bldg.maplot and
>>  commcost.unitno = bldg.unitno)
>>  order by commcost.maplot
>
>or simply write:
>
>select * from commcost except select * from bldg;
>
>depesz

Thank you very much for your quick response!

-Owen